package oracle.springbootxm.dao.menudao;

import oracle.springbootxm.pojo.MenuInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface MenuMapper {
    @Select("select * from t_menu")
    @Results(
            {
                    @Result(property = "menuid", column = "menu_id"),
                    @Result(property = "menuName", column = "menu_name"),
                    @Result(property = "menuURL", column = "menu_url"),
                    @Result(property = "menuAuthid", column = "menu_authid"),
                    @Result(property = "oper", column = "menu_oper"),
                    @Result(property = "parentid", column = "menu_parent"),
                    @Result(property = "status", column = "menu_status")
            }
    )
    List<MenuInfo> queryMenuInfo();
}
